Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

National Language Support

After the DataServer connects to ORACLE, it issues the following statements to set National Language Support (NLS) parameters for the ORACLE environment:

ALTER SESSION SET NLS_DATE_FORMAT = ’YYYYMMDD’ ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ’.,’

These settings might affect how stored procedures (including those using the send-sql-statement option) behave. Specifically, the default format that the TO_DATE function and the format of a date returned might be different. Always specify the format for the date as the second argument to the TO_DATE and TO_CHAR functions when dealing with date values.